home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / optypes.ctl < prev    next >
Text File  |  2000-05-12  |  1KB  |  41 lines
  1. -- RCSVER $Id: optypes.ctl,v 1.4 1999-09-20 14:30:18-05 evan CURRENT $ */
  2. -- *************************************************************************
  3. --        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. --
  5. -- Name:        optypes.ctl 
  6. -- Date:     02/17/1999
  7. -- memo:        Randy Wood
  8. -- Description:    Load the data for the optypes table.
  9. -- Changes:
  10. -- ********************************************************************** */
  11. LOAD DATA
  12. INFILE *
  13. INTO TABLE optypes
  14. fields terminated by "|"
  15. trailing nullcols
  16. (
  17.     op_type,    
  18.     op_description,
  19.     subsys_id
  20. )
  21. begindata
  22. 1|Computer system administrator|1|
  23. 2|Computer system administrator|2|
  24. 3|Computer system administrator|3|
  25. 4|Bus operator|4|
  26. 5|Shift supervisor|2|
  27. 6|Shift supervisor|3|
  28. 7|Shift supervisor|4|
  29. 8|Accounting|1|
  30. 9|Maintenance|4|
  31. 10|Revenue servicing|3|
  32. 11|Moneyroom worker|2|
  33. 12|Revenue Administrator|1|
  34. 13|Revenue Administrator|2|
  35. 14|Revenue Administrator|3|
  36. 15|Revenue Administrator|4|
  37. 16|Manager|1|
  38. 17|Manager|2|
  39. 18|Manager|3|
  40. 19|Manager|4|
  41.